package vn.candyapp.qlct.database.model;

public class Table {
	
	public static final String TABLE_ACCOUNT = "accounts";
	public static final String TABLE_TRANSACTION = "da_transaction";
	public static final String TABLE_CATEGORY = "category";
	public static final String TABLE_USER = "user";
	public static final String TABLE_PAYMENT_STATUS = "payment_status";
	public static final String TABLE_TRANSACTION_TYPE = "transaction_type";
	
	public static final String KEY_ACCOUNT_ID = "id";
	public static final String KEY_ACCOUNT_NAME = "name";
	public static final String KEY_ACCOUNT_BALANCE = "balance";
	public static final String KEY_ACCOUNT_CURRENCY = "currency";
	public static final String KEY_ACCOUNT_CREATED_DATE = "created_date";
	public static final String KEY_ACCOUNT_IS_CREDIT_CARD = "is_credit_card";
	
	public static final String KEY_CATEGORY_ID = "id";
	public static final String KEY_CATEGORY_NAME = "name";
	public static final String KEY_CATEGORY_DESCRIPTION = "description";
	public static final String KEY_CATEGORY_ORDER_NO = "order_no";
	public static final String KEY_CATEGORY_TRANSACTION_TYPE = "transaction_type";
	public static final String KEY_CATEGORY_COLOR = "color";
	
	public static final String KEY_TRANSACTION_ID = "id";
	public static final String KEY_TRANSACTION_ACCOUNT_ID = "account_id";
	public static final String KEY_TRANSACTION_CATEGORY_ID = "category_id";
	public static final String KEY_TRANSACTION_USER_ID = "user_id";
	public static final String KEY_TRANSACTION_TRANSACTION_TYPE = "transaction_type";
	public static final String KEY_TRANSACTION_PAYMENT_STATUS = "payment_status";
	public static final String KEY_TRANSACTION_AMOUNT = "amount";
	public static final String KEY_TRANSACTION_DESCRIPTION = "description";
	public static final String KEY_TRANSACTION_CREATED_DATE = "created_date";
	
	
	public static final String KEY_USER_ID = "id";
	public static final String KEY_USER_NAME = "name";
	public static final String KEY_USER_ORDER_NO = "order_no";
	public static final String KEY_USER_DESCRIPTION = "description";
	
	public static final String KEY_PAYMENT_STATUS_ID = "id";
	public static final String KEY_PAYMENT_STATUS_NAME = "name";
	public static final String KEY_PAYMENT_STATUS_DESCRIPTION = "description";
	public static final String KEY_PAYMENT_STATUS_ORDER_NO = "order_no";
	public static final String KEY_PAYMENT_STATUS_IS_DEFAULT = "is_default";
	public static final String KEY_PAYMENT_STATUS_IS_COMPLETED = "is_completed";
	
	public static final String KEY_TRANSACTION_TYPE_ID = "id";
	public static final String KEY_TRANSACTION_TYPE_NAME = "name";
	public static final String KEY_TRANSACTION_TYPE_IS_DEFAULT = "is_default";
	public static final String KEY_TRANSACTION_TYPE_TYPE_NAME = "type_name";
	
	
}
